<!DOCTYPE html><html xmlns:date="http://exslt.org/dates-and-times" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="viewport" content="width=device-width; initial-scale=1.0; maximum-scale=1.0; user-scalable=0;">
<meta charset="utf-8">
<title>Plurious Framework » \framework\library\database\DB</title>
<meta name="author" content="Mike van Riel">
<meta name="description" content="">
<link href="../css/template.css" rel="stylesheet" media="all">
<script src="../js/jquery-1.7.1.min.js" type="text/javascript"></script><script src="../js/jquery-ui-1.8.2.custom.min.js" type="text/javascript"></script><script src="../js/jquery.mousewheel.min.js" type="text/javascript"></script><script src="../js/bootstrap.js" type="text/javascript"></script><script src="../js/template.js" type="text/javascript"></script><script src="../js/prettify/prettify.min.js" type="text/javascript"></script><link rel="shortcut icon" href="../img/favicon.ico">
<link rel="apple-touch-icon" href="../img/apple-touch-icon.png">
<link rel="apple-touch-icon" sizes="72x72" href="../img/apple-touch-icon-72x72.png">
<link rel="apple-touch-icon" sizes="114x114" href="../img/apple-touch-icon-114x114.png">
</head>
<body>
<div class="navbar navbar-fixed-top">
<div class="navbar-inner"><div class="container">
<a class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse"><span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span></a><a class="brand" href="../index.html">Plurious Framework</a><div class="nav-collapse"><ul class="nav">
<li class="dropdown">
<a href="#api" class="dropdown-toggle" data-toggle="dropdown">
                                    API Documentation <b class="caret"></b></a><ul class="dropdown-menu">
<li><a>Namespaces</a></li>
<li><a href="../namespaces/framework.html"><i class="icon-th"></i> framework</a></li>
<li><a href="../namespaces/global.html"><i class="icon-th"></i> global</a></li>
<li><a href="../namespaces/plurious.html"><i class="icon-th"></i> plurious</a></li>
</ul>
</li>
<li class="dropdown" id="charts-menu">
<a href="#charts" class="dropdown-toggle" data-toggle="dropdown">
                                    Charts <b class="caret"></b></a><ul class="dropdown-menu"><li><a href="../graph_class.html"><i class="icon-list-alt"></i> Class hierarchy diagram</a></li></ul>
</li>
<li class="dropdown" id="reports-menu">
<a href="#reports" class="dropdown-toggle" data-toggle="dropdown">
                                    Reports <b class="caret"></b></a><ul class="dropdown-menu">
<li><a href="../errors.html"><i class="icon-remove-sign"></i> Errors 
                <span class="label label-info">439</span></a></li>
<li><a href="../markers.html"><i class="icon-map-marker"></i> Markers 
                <ul><li>todo 
                <span class="label label-info">82</span>
</li></ul></a></li>
<li><a href="../deprecated.html"><i class="icon-stop"></i> Deprecated elements 
                <span class="label label-info">0</span></a></li>
</ul>
</li>
</ul></div>
</div></div>
<div class="go_to_top"><a href="#___" style="color: inherit">Back to top  <i class="icon-upload icon-white"></i></a></div>
</div>
<div id="___" class="container">
<noscript><div class="alert alert-warning">
                            Javascript is disabled; several features are only available
                            if Javascript is enabled.
                        </div></noscript>
<div class="row">
<div class="span4">
<span class="btn-group visibility" data-toggle="buttons-checkbox"><button class="btn public active" title="Show public elements">Public</button><button class="btn protected" title="Show protected elements">Protected</button><button class="btn private" title="Show private elements">Private</button><button class="btn inherited active" title="Show inherited elements">Inherited</button></span><div class="btn-group view pull-right" data-toggle="buttons-radio">
<button class="btn details" title="Show descriptions and method names"><i class="icon-list"></i></button><button class="btn simple" title="Show only method names"><i class="icon-align-justify"></i></button>
</div>
<ul class="side-nav nav nav-list">
<li class="nav-header">
<i class="icon-custom icon-method"></i> Methods</li>
<li class="method public "><a href="#__clone" title="__clone :: "><span class="description">__clone()
        </span><pre>__clone()</pre></a></li>
<li class="method public "><a href="#__destruct" title="__destruct :: Closes the DB Connection upon Object removal"><span class="description">Closes the DB Connection upon Object removal</span><pre>__destruct()</pre></a></li>
<li class="method public "><a href="#__wakeup" title="__wakeup :: "><span class="description">__wakeup()
        </span><pre>__wakeup()</pre></a></li>
<li class="method public inherited"><a href="#delete" title="delete :: Creates PDO Parameterized DELETE statement and executes the DELETE"><span class="description">Creates PDO Parameterized DELETE statement and executes the DELETE</span><pre>delete()</pre></a></li>
<li class="method public "><a href="#getColumns" title="getColumns :: Creates a string of comma separated arrray keys."><span class="description">Creates a string of comma separated arrray keys.</span><pre>getColumns()</pre></a></li>
<li class="method public "><a href="#getInstance" title="getInstance :: Returns Singleton Instance"><span class="description">Returns Singleton Instance</span><pre>getInstance()</pre></a></li>
<li class="method public "><a href="#getQueryParams" title="getQueryParams :: Creates string of arrays keys prepended with ':' to be used as
PDO query parameters"><span class="description">Creates string of arrays keys prepended with ':' to be used as
PDO query parameters</span><pre>getQueryParams()</pre></a></li>
<li class="method public inherited"><a href="#insert" title="insert :: Creates PDO Parameterized INSERT statement and executes the INSERT"><span class="description">Creates PDO Parameterized INSERT statement and executes the INSERT</span><pre>insert()</pre></a></li>
<li class="method public "><a href="#lastInsertId" title="lastInsertId :: Retrieves the last id inserted into a table."><span class="description">Retrieves the last id inserted into a table.</span><pre>lastInsertId()</pre></a></li>
<li class="method public "><a href="#query" title="query :: "><span class="description">query()
        </span><pre>query()</pre></a></li>
<li class="method public inherited"><a href="#select" title="select :: Creates PDO Parameterized SELECT statement and executes the SELECT"><span class="description">Creates PDO Parameterized SELECT statement and executes the SELECT</span><pre>select()</pre></a></li>
<li class="method public inherited"><a href="#selectCols" title="selectCols :: Creates PDO Parameterized SELECT statement and executes the SELECT"><span class="description">Creates PDO Parameterized SELECT statement and executes the SELECT</span><pre>selectCols()</pre></a></li>
<li class="method public inherited"><a href="#setOrder" title="setOrder :: Sets the Column and Direction for sort operations."><span class="description">Sets the Column and Direction for sort operations.</span><pre>setOrder()</pre></a></li>
<li class="method public inherited"><a href="#testOutput" title="testOutput :: Pretty prints a debug dump of the operation performed."><span class="description">Pretty prints a debug dump of the operation performed.</span><pre>testOutput()</pre></a></li>
<li class="method public inherited"><a href="#update" title="update :: Creates PDO Parameterized UPDATE statement and executes the UPDATE"><span class="description">Creates PDO Parameterized UPDATE statement and executes the UPDATE</span><pre>update()</pre></a></li>
<li class="method public inherited"><a href="#whereEquals" title="whereEquals :: Combines SQL WHERE clause with sql passed into method."><span class="description">Combines SQL WHERE clause with sql passed into method.</span><pre>whereEquals()</pre></a></li>
<li class="nav-header protected">» Protected</li>
<li class="method protected "><a href="#exec" title="exec :: Uses PDO to prepare SQL statements, close stale cursors &amp;
execute PDO statements"><span class="description">Uses PDO to prepare SQL statements, close stale cursors &amp;
execute PDO statements</span><pre>exec()</pre></a></li>
<li class="nav-header private">» Private</li>
<li class="method private "><a href="#__construct" title="__construct :: A Private Constructor;"><span class="description">A Private Constructor;</span><pre>__construct()</pre></a></li>
<li class="nav-header">
<i class="icon-custom icon-property"></i> Properties</li>
<li class="property public "><a href="#%24db" title="$db :: Holds PDO Object"><span class="description">Holds PDO Object</span><pre>$db</pre></a></li>
<li class="nav-header private">» Private</li>
<li class="property private "><a href="#%24dbRef" title="$dbRef :: Holds static instannce reference for Singleton"><span class="description">Holds static instannce reference for Singleton</span><pre>$dbRef</pre></a></li>
<li class="property private inherited"><a href="#%24order_by_col" title="$order_by_col :: Holds Column name for sorting operations"><span class="description">Holds Column name for sorting operations</span><pre>$order_by_col</pre></a></li>
<li class="property private inherited"><a href="#%24order_direction" title="$order_direction :: Holds sorting direction (ASC, DESC) for sorting operations"><span class="description">Holds sorting direction (ASC, DESC) for sorting operations</span><pre>$order_direction</pre></a></li>
<li class="property private "><a href="#%24statement_counter" title="$statement_counter :: Indicates Number of active statement objects"><span class="description">Indicates Number of active statement objects</span><pre>$statement_counter</pre></a></li>
</ul>
</div>
<div class="span8">
<a name="%5Cframework%5Clibrary%5Cdatabase%5CDB" id="\framework\library\database\DB"></a><ul class="breadcrumb">
<li>
<a href="../index.html"><i class="icon-custom icon-class"></i></a><span class="divider">\</span>
</li>
<li><a href="../namespaces/framework.html">framework</a></li>
<span class="divider">\</span><li><a href="../namespaces/framework.library.html">library</a></li>
<span class="divider">\</span><li><a href="../namespaces/framework.library.database.html">database</a></li>
<li class="active">
<span class="divider">\</span><a href="../classes/framework.library.database.DB.html">DB</a>
</li>
</ul>
<div href="../classes/framework.library.database.DB.html" class="element class">
<p class="short_description">DB Class</p>
<div class="details">
<p class="long_description"><p>Plurious Database</p>

<p>Generic PDO Abstraction Class</p>

<p>NOTE: There shoul be no SQL in this file!</p></p>
<table class="table table-bordered">
<tr>
<th>author</th>
<td><a href="mailto:randy@plurious.com">Randy Casburn</a></td>
</tr>
<tr>
<th>copyright</th>
<td>Copyright Plurious Software, all rights reserved</td>
</tr>
<tr>
<th>license</th>
<td><a href="http://opensource.org/licenses/MIT">MIT</a></td>
</tr>
<tr>
<th>license</th>
<td><a href="http://www.opensource.org/licenses/mit-license.html">http://www.opensource.org/licenses/mit-license.html</a></td>
</tr>
<tr>
<th>link</th>
<td><a href="http://plurious.com/framework/documentation/classes/Front.html">http://plurious.com/framework/documentation/classes/Front.html</a></td>
</tr>
<tr>
<th>version</th>
<td>2.1</td>
</tr>
<tr>
<th>uses</th>
<td>\framework\library\database\Query_Builder</td>
</tr>
<tr>
<th>uses</th>
<td>\PDO</td>
</tr>
<tr>
<th>used_by</th>
<td>\framework\library\Config</td>
</tr>
<tr>
<th>used_by</th>
<td>\framework\library\ConfigException</td>
</tr>
<tr>
<th>used_by</th>
<td>\framework\library\Model</td>
</tr>
</table>
<h3>
<i class="icon-custom icon-method"></i> Methods</h3>
<a name="__clone" id="__clone"></a><div class="element clickable method public __clone" data-toggle="collapse" data-target=".__clone .collapse">
<h2>__clone()
        </h2>
<pre>__clone() </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><p class="long_description"></p></div></div>
</div>
<a name="__destruct" id="__destruct"></a><div class="element clickable method public __destruct" data-toggle="collapse" data-target=".__destruct .collapse">
<h2>Closes the DB Connection upon Object removal</h2>
<pre>__destruct() </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><p class="long_description"></p></div></div>
</div>
<a name="__wakeup" id="__wakeup"></a><div class="element clickable method public __wakeup" data-toggle="collapse" data-target=".__wakeup .collapse">
<h2>__wakeup()
        </h2>
<pre>__wakeup() </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><p class="long_description"></p></div></div>
</div>
<a name="delete" id="delete"></a><div class="element clickable method public delete" data-toggle="collapse" data-target=".delete .collapse">
<h2>Creates PDO Parameterized DELETE statement and executes the DELETE</h2>
<pre>delete(string $table, array $where) : int</pre>
<div class="labels"><span class="label">Inherited</span></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"><p>This method will not execute without a defined where clause.</p></p>
<table class="table table-bordered"><tr>
<th>inherited_from</th>
<td>\framework\library\database\Query_Builder::delete()</td>
</tr></table>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$table</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$where</h4>
<code>array</code>
</div>
<h3>Returns</h3>
<div class="subelement response">
<code>int</code>Count of affected rows</div>
</div></div>
</div>
<a name="getColumns" id="getColumns"></a><div class="element clickable method public getColumns" data-toggle="collapse" data-target=".getColumns .collapse">
<h2>Creates a string of comma separated arrray keys.</h2>
<pre>getColumns(array $data) : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"><p>Used to create the field listing for SQL statements (upates, inserts).</p></p>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$data</h4>
<code>array</code>
</div>
<h3>Returns</h3>
<div class="subelement response">
<code>string</code>of comma separated array keys</div>
</div></div>
</div>
<a name="getInstance" id="getInstance"></a><div class="element clickable method public getInstance" data-toggle="collapse" data-target=".getInstance .collapse">
<h2>Returns Singleton Instance</h2>
<pre>getInstance(string $type, string $host, string $db_name, string $user, string $password, array $params, int $port) : \framework\library\database\Instance</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"></p>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$type</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$host</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$db_name</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$user</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$password</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$params</h4>
<code>array</code>
</div>
<div class="subelement argument">
<h4>$port</h4>
<code>int</code>
</div>
<h3>Returns</h3>
<div class="subelement response">
<code>\framework\library\database\Instance</code>Mysql_DB Object</div>
</div></div>
</div>
<a name="getQueryParams" id="getQueryParams"></a><div class="element clickable method public getQueryParams" data-toggle="collapse" data-target=".getQueryParams .collapse">
<h2>Creates string of arrays keys prepended with ':' to be used as
PDO query parameters</h2>
<pre>getQueryParams(array $data) : string</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"></p>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$data</h4>
<code>array</code>
</div>
<h3>Returns</h3>
<div class="subelement response">
<code>string</code>PDO query parameters</div>
</div></div>
</div>
<a name="insert" id="insert"></a><div class="element clickable method public insert" data-toggle="collapse" data-target=".insert .collapse">
<h2>Creates PDO Parameterized INSERT statement and executes the INSERT</h2>
<pre>insert(string $table, array $data) : int</pre>
<div class="labels"><span class="label">Inherited</span></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"></p>
<table class="table table-bordered"><tr>
<th>inherited_from</th>
<td>\framework\library\database\Query_Builder::insert()</td>
</tr></table>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$table</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$data</h4>
<code>array</code>
</div>
<h3>Returns</h3>
<div class="subelement response">
<code>int</code>Id of inserted record</div>
</div></div>
</div>
<a name="lastInsertId" id="lastInsertId"></a><div class="element clickable method public lastInsertId" data-toggle="collapse" data-target=".lastInsertId .collapse">
<h2>Retrieves the last id inserted into a table.</h2>
<pre>lastInsertId() : int</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"></p>
<h3>Returns</h3>
<div class="subelement response">
<code>int</code>id of most recent inserted record</div>
</div></div>
</div>
<a name="query" id="query"></a><div class="element clickable method public query" data-toggle="collapse" data-target=".query .collapse">
<h2>query()
        </h2>
<pre>query($sql, array $values) </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"></p>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$sql</h4>
<code></code>
</div>
<div class="subelement argument">
<h4>$values</h4>
<code></code>
</div>
</div></div>
</div>
<a name="select" id="select"></a><div class="element clickable method public select" data-toggle="collapse" data-target=".select .collapse">
<h2>Creates PDO Parameterized SELECT statement and executes the SELECT</h2>
<pre>select(string $table, array $where, int $limit) : array</pre>
<div class="labels"><span class="label">Inherited</span></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"></p>
<table class="table table-bordered"><tr>
<th>inherited_from</th>
<td>\framework\library\database\Query_Builder::select()</td>
</tr></table>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$table</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$where</h4>
<code>array</code>
</div>
<div class="subelement argument">
<h4>$limit</h4>
<code>int</code>
</div>
<h3>Returns</h3>
<div class="subelement response">
<code>array</code>Associative Array of DB rows</div>
</div></div>
</div>
<a name="selectCols" id="selectCols"></a><div class="element clickable method public selectCols" data-toggle="collapse" data-target=".selectCols .collapse">
<h2>Creates PDO Parameterized SELECT statement and executes the SELECT</h2>
<pre>selectCols(string $table, array $cols, array $where, int $limit) : array</pre>
<div class="labels"><span class="label">Inherited</span></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"></p>
<table class="table table-bordered"><tr>
<th>inherited_from</th>
<td>\framework\library\database\Query_Builder::selectCols()</td>
</tr></table>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$table</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$cols</h4>
<code></code>
</div>
<div class="subelement argument">
<h4>$where</h4>
<code>array</code>
</div>
<div class="subelement argument">
<h4>$limit</h4>
<code>int</code>
</div>
<h3>Returns</h3>
<div class="subelement response">
<code>array</code>Associative Array of DB rows</div>
</div></div>
</div>
<a name="setOrder" id="setOrder"></a><div class="element clickable method public setOrder" data-toggle="collapse" data-target=".setOrder .collapse">
<h2>Sets the Column and Direction for sort operations.</h2>
<pre>setOrder(string $col, string $dir) </pre>
<div class="labels"><span class="label">Inherited</span></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"><p>NOTE: you must reset these parameters when finished with them. Otherwise
all results following will be sorted using these criteria.</p>

<p>To clear the sort criteria simply call this method with
no parameters passed -- setOrder();</p></p>
<table class="table table-bordered"><tr>
<th>inherited_from</th>
<td>\framework\library\database\Query_Builder::setOrder()</td>
</tr></table>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$col</h4>
<code>string</code><p>The name of the column to sort results on</p></div>
<div class="subelement argument">
<h4>$dir</h4>
<code>string</code><p>Should be ASC or DESC</p></div>
</div></div>
</div>
<a name="testOutput" id="testOutput"></a><div class="element clickable method public testOutput" data-toggle="collapse" data-target=".testOutput .collapse">
<h2>Pretty prints a debug dump of the operation performed.</h2>
<pre>testOutput(string $title, string $sql, array $values, int $numRows, boolean $isQuery) : null</pre>
<div class="labels"><span class="label">Inherited</span></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"></p>
<table class="table table-bordered"><tr>
<th>inherited_from</th>
<td>\framework\library\database\Query_Builder::testOutput()</td>
</tr></table>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$title</h4>
<code>string</code><p>Test Title</p></div>
<div class="subelement argument">
<h4>$sql</h4>
<code>string</code><p>SQL statement</p></div>
<div class="subelement argument">
<h4>$values</h4>
<code>array</code><p>Data used for query</p></div>
<div class="subelement argument">
<h4>$numRows</h4>
<code>int</code><p>Affected Row Count</p></div>
<div class="subelement argument">
<h4>$isQuery</h4>
<code>boolean</code><p>for constructing the SQL statement</p></div>
<h3>Returns</h3>
<div class="subelement response">
<code>null</code>If not in debug mode</div>
</div></div>
</div>
<a name="update" id="update"></a><div class="element clickable method public update" data-toggle="collapse" data-target=".update .collapse">
<h2>Creates PDO Parameterized UPDATE statement and executes the UPDATE</h2>
<pre>update(array $new_values, string $table, array $where) : int</pre>
<div class="labels"><span class="label">Inherited</span></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"></p>
<table class="table table-bordered"><tr>
<th>inherited_from</th>
<td>\framework\library\database\Query_Builder::update()</td>
</tr></table>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$new_values</h4>
<code>array</code>
</div>
<div class="subelement argument">
<h4>$table</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$where</h4>
<code>array</code>
</div>
<h3>Returns</h3>
<div class="subelement response">
<code>int</code>Count of affected rows</div>
</div></div>
</div>
<a name="whereEquals" id="whereEquals"></a><div class="element clickable method public whereEquals" data-toggle="collapse" data-target=".whereEquals .collapse">
<h2>Combines SQL WHERE clause with sql passed into method.</h2>
<pre>whereEquals(string $sql, array $where) : array</pre>
<div class="labels"><span class="label">Inherited</span></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"></p>
<table class="table table-bordered"><tr>
<th>inherited_from</th>
<td>\framework\library\database\Query_Builder::whereEquals()</td>
</tr></table>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$sql</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$where</h4>
<code>array</code>
</div>
<h3>Returns</h3>
<div class="subelement response">
<code>array</code>Index 0 contains the sql statement, Index 1 contains the data</div>
</div></div>
</div>
<a name="exec" id="exec"></a><div class="element clickable method protected exec" data-toggle="collapse" data-target=".exec .collapse">
<h2>Uses PDO to prepare SQL statements, close stale cursors &amp;
execute PDO statements</h2>
<pre>exec(string $sql, array $values) : \framework\library\database\PDO::Statement</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"><p>Logs error to pdo_errors.txt</p></p>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$sql</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$values</h4>
<code>array</code>
</div>
<h3>Returns</h3>
<div class="subelement response"><code>\framework\library\database\PDO::Statement</code></div>
</div></div>
</div>
<a name="__construct" id="__construct"></a><div class="element clickable method private __construct" data-toggle="collapse" data-target=".__construct .collapse">
<h2>A Private Constructor;</h2>
<pre>__construct(string $type, string $host, string $db_name, string $user, string $password, int $port) : Object</pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"><p>Constructs PDO Abstraction object.</p></p>
<h3>Parameters</h3>
<div class="subelement argument">
<h4>$type</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$host</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$db_name</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$user</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$password</h4>
<code>string</code>
</div>
<div class="subelement argument">
<h4>$port</h4>
<code>int</code>
</div>
<h3>Returns</h3>
<div class="subelement response">
<code>Object</code>PDO Object</div>
</div></div>
</div>
<h3>
<i class="icon-custom icon-property"></i> Properties</h3>
<a name="%24db" id="$db"> </a><div class="element clickable property public $db" data-toggle="collapse" data-target=".$db .collapse">
<h2>Holds PDO Object</h2>
<pre>$db </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><p class="long_description"></p></div></div>
</div>
<a name="%24dbRef" id="$dbRef"> </a><div class="element clickable property private $dbRef" data-toggle="collapse" data-target=".$dbRef .collapse">
<h2>Holds static instannce reference for Singleton</h2>
<pre>$dbRef </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><p class="long_description"></p></div></div>
</div>
<a name="%24order_by_col" id="$order_by_col"> </a><div class="element clickable property private $order_by_col" data-toggle="collapse" data-target=".$order_by_col .collapse">
<h2>Holds Column name for sorting operations</h2>
<pre>$order_by_col </pre>
<div class="labels"><span class="label">Inherited</span></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"></p>
<table class="table table-bordered"><tr>
<th>inherited_from</th>
<td>\framework\library\database\Query_Builder::$$order_by_col</td>
</tr></table>
</div></div>
</div>
<a name="%24order_direction" id="$order_direction"> </a><div class="element clickable property private $order_direction" data-toggle="collapse" data-target=".$order_direction .collapse">
<h2>Holds sorting direction (ASC, DESC) for sorting operations</h2>
<pre>$order_direction </pre>
<div class="labels"><span class="label">Inherited</span></div>
<div class="row collapse"><div class="detail-description">
<p class="long_description"></p>
<table class="table table-bordered"><tr>
<th>inherited_from</th>
<td>\framework\library\database\Query_Builder::$$order_direction</td>
</tr></table>
</div></div>
</div>
<a name="%24statement_counter" id="$statement_counter"> </a><div class="element clickable property private $statement_counter" data-toggle="collapse" data-target=".$statement_counter .collapse">
<h2>Indicates Number of active statement objects</h2>
<pre>$statement_counter </pre>
<div class="labels"></div>
<div class="row collapse"><div class="detail-description"><p class="long_description"></p></div></div>
</div>
</div>
</div>
</div>
</div>
<div class="row"><footer class="span12">
            Template is built using <a href="http://twitter.github.com/bootstrap/">Twitter Bootstrap 2</a> and icons provided by <a href="http://glyphicons.com/">Glyphicons</a>.<br>
            Documentation is powered by <a href="http://www.phpdoc.org/">phpDocumentor 2.0.0a7</a> and<br>
            generated on 2012-07-06T18:53:43-05:00.<br></footer></div>
</div>
</body>
</html>
